package com.youpingou.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.youpingou.domain.Address;
import com.youpingou.domain.Brand;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface BrandMapper extends BaseMapper<Brand> {

    @Select("select * from tb_brand where id in (select brand_id from tb_category_brand where category_id = #{cat3id})")
    public List<Brand> findBrandByCat3id(Integer cat3id);


}